Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SQLSET_BINDS

`ALL_SQLSET_BINDS` displays the bind values associated with all SQL tuning sets accessible to the current user.

Related Views

- `DBA_SQLSET_BINDS` displays the bind values associated with all SQL tuning sets in the database.

- `USER_SQLSET_BINDS` displays the bind values associated with the SQL tuning sets owned by the current user. This view does not display the `SQLSET_OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SQLSET_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the SQL tuning set for the statement
`SQLSET_OWNER` | `VARCHAR2(30)` |  | User name of the SQL tuning set owner
`SQLSET_ID` | `NUMBER` | `NOT NULL` | ID of the SQL tuning set for the statement
`SQL_ID` | `VARCHAR2(13)` | `NOT NULL` | SQL identifier of the parent cursor in the library cache
`FORCE_MATCHING_SIGNATURE` | `NUMBER` | `NOT NULL` | The signature used when the `CURSOR_SHARING` parameter is set to `FORCE`
`PLAN_HASH_VALUE` | `NUMBER` | `NOT NULL` | Numerical representation of the SQL plan for the cursor. Comparing one `PLAN_HASH_VALUE` to another easily identifies whether or not two plans are the same (rather than comparing the two plans line-by-line).
`POSITION` | `NUMBER` | `NOT NULL` | Position
`VALUE` | `ANYDATA` |  | Value
`CAPTURED` | `CHAR(1)` |  | Binds captured
`SQL_SEQ` | `NUMBER` | `NOT NULL` | SQL sequence